| |
192 Search Results Found |
| 1 |
Forum: Server Administration «»
Posted on: Tue, 12 February 2019 08:34 «»
By: wtolentino
Re: How To Get the username that is currently Proxy To
…so much saw some that might help. then found the dba_audit_trail might help with the use of column action_name = 'PROXY AUTHENTICATION ONLY'. from that table there is a column sessionid where can I link this column to other tables that might help me get …
|
| 2 |
Forum: Security «»
Posted on: Mon, 05 November 2018 06:47 «»
By: muthukrish104
Who locked oracle user
…Everyone,
I want to know who locked the account.
Our parameter setup is:-
audit_file_dest string C:\ORACLE\ORA12C\HOME\DBS\ADMIN\ADUMP
audit_sys_operations boolean…
|
| 3 |
Forum: Backup & Recovery «»
Posted on: Sun, 25 March 2018 22:23 «»
By: BlackSwan
Re: ORA-27072: File I/O error for sysaux.dbf, more logfiles than expected
…
select
relative_fno,
owner,
segment_name,
segment_type
from
dba_extents
where
file_id in (SELECT FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'SYSAUX')
and
105600 between block_id and block_id + blocks - 1…
|
| 4 |
Forum: Server Utilities «»
Posted on: Fri, 08 December 2017 12:18 «»
By: rocioperezn
loading data from twitter with sqlldr
…all,
I have some problems loading a twitter data from a csv, with some multiline records. I have 4 columns id_tweet,text,created_at, username .
When text is enclosed by " the register is multiline or has comas inside, I show you 3 examples, …
|
| 5 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Mon, 02 January 2017 06:58 «»
By: apexmahfuj
Hide schema name,username and password from url
…Hi,
I have called a rdf report (10g) from an apex page by passing three parameters and its working.
My report runs without no error.
But what have I found that the whole information such as schema name,user_name,password are showing in the path…
|
| 6 |
Forum: Reports & Discoverer «»
Posted on: Fri, 11 September 2015 04:14 «»
By: limig
Re: Problem while running two reports consecutively
…Forms, the following is called:
RUN_REPORT_OBJECT_PROC(v_report_id, vch_rep_srv, 'PDF', CACHE, v_report_file_name, v_report_other, '/reports/rwservlet') ;
--[v_report_id = report_object; vch_rep_srv = report server; v_report_other = parameter list]
…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 05 March 2015 05:40 «»
By: Solomon Yakobson
Re: Writing a Hierarchical Query without using the connect by prior
…believe SYBASE same as MS SQL and Oracle support recursive subquery factoring:
SQL> with user_hierarchy as (
2 select userid, username, user_group, user_type, level as level_num
3 from users
4 start with userid…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 March 2015 12:04 «»
By: sachinj
Writing a Hierarchical Query without using the connect by prior
…
--Table Creation Script
CREATE TABLE USERS
(
USERID INTEGER NOT NULL,
USERNAME VARCHAR2(255 BYTE) NOT NULL,
FULLNAME VARCHAR2(255 BYTE) NOT NULL,
USER_GROUP…
|
| 9 |
Forum: Reports & Discoverer «»
Posted on: Thu, 22 January 2015 02:51 «»
By: nickron
Error while converting Reports from rdf to rep
…the following command:
rwconverter.sh userid=username/password batch=yes
source=$i stype=rdffile dtype=rdffile overwrite=yes
compile_all=yes
getting below error…
|
| 10 |
Forum: Server Administration «»
Posted on: Mon, 19 January 2015 12:46 «»
By: BlackSwan
Re: Slow databases on a Solaris server after flushing buffer cache of one database
…dbv against /u01/oradata/db1/system1.dbf
[oracle@localhost ~]$ dbv
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Jan 19 10:45:44 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Keyword Description…
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 15:12 «»
By: Bill B
Re: Help with pre 9i Join to ANSI standard
…about
SELECT table_t2.username,
table_t1.date,
table_t1.days,
table_t1.loginid
FROM TABLE_T1 CROSS JOIN TABLE_T2 CROSS JOIN TABLE_T3 CROSS JOIN TABLE_T4
WHERE ( ( ( ( ( (table_t1.statement = table_t2.…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:55 «»
By: cookiemonster
Re: Help with pre 9i Join to ANSI standard
…Ok, So Here's the issues:
1) Those brackets don't actually do anything useful, so you should just lose them.
2) You're mixing join styles - if you're using ANSI joins you should use them for all tables, so there should be an inner join for t1 and t2 …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:20 «»
By: sucheta
Re: Help with pre 9i Join to ANSI standard
…is my ANSI attempt and attempt to get it to the correct formatting, syntax, etc for all here to view. I see what everyone means about the + now. My mistake obviously. Apologies. Yes table_t3.alternateid is nullable.
SELECT table_t2.username…
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 23 April 2014 07:21 «»
By: EdStevens
Re: ORA-28002 error while connecting DB LINK
…cookiemonster said, the error means exactly what it says.
To explain a bit further and perhaps clarify your understanding ...
A database link connects to another database just like any other client process. If dbA has a link pointing to dbB, as …
|
| 15 |
Forum: General «»
Posted on: Mon, 31 March 2014 00:34 «»
By: kesavansundaram
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…you Mike and every one who worked for me.
below works well for me now.
col "DBMS" for a15
col "Host Name" for a30
col "OS UserID" for a15
col "User Machine" for a18
col "Time(G)" for a36
col &…
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 11 February 2014 01:21 «»
By: sarfraz_attari
Re: Error in PL/SQL Procedure using UTL_HTTP
…am still waiting for the solution of this problem
when I modified the code of my PL/SQL with this
[Code]
PROCEDURE expert_http IS
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
name VARCHAR2(1024);
value VARCHAR2(1024);
url VARCHAR2(4000…
|
| 17 |
Forum: Forms «»
Posted on: Mon, 25 November 2013 00:00 «»
By: jyothilekshmir2006
Re: Hiding hostname, username and password in URL (10g)
GO TO CONFIGURATION FILE 'reports/conf/cgicmd.dat' . then create a variable like this
rep: userid=username/password@database %* then use this rep instead of username/pass@db in your url
THANKS
JYOTHI
|
| 18 |
Forum: Weblogic & Application Server «»
Posted on: Sat, 08 June 2013 02:37 «»
By: ranamirfan
Re: How to encrypte the form, report calling addresses Or hide the address
…Dear,
1- Set your REPORTS_PATH in Registry
D:\10gpayroll\reports;
2- Define your UserName & Password / Report Server Name / Desformat & destype in Your cgicmd.dat file.
usr: userid=PR/CAAPR2013@hpdb Server=…
|
| 19 |
Forum: Networking and Gateways «»
Posted on: Tue, 05 March 2013 07:59 «»
By: sakamboh
Re: ORA-02047: cannot join the distributed transaction in progress
…Guys i have resolved the issue but their is a drawback of this solution... can anyone help me with this... I have modified my triger and now its working fine... but if i rollback in oracle it doesnot rollback in SQL. Please check below.
create or …
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 06:21 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…Michel coupled with your advice and some stuff in the docs and the web i was able to come up with a solution. the only issue i get with this is that when i try to open the pdf it complains that the pdf is already open, when close adobe reader and open it …
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 03:22 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…
declare
lf_file utl_file.file_type;
lr_raw_data raw(32767);
lb_clob_response clob;
lh_http_request utl_http.req;
lh_http_response utl_http.resp;
ln_counter pls_integer := 0;
ln_substr_len…
|
| 22 |
Forum: Forms «»
Posted on: Sat, 20 October 2012 03:28 «»
By: hissam78
LOGIN USER FROM ONE CANVAS AND ACCESS SECOND CANVAS AS PER USER RIGHTS
…ALL,
- we have user id parameter.
can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another
canvas as per user rights?
- i …
|
| 23 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 16 August 2012 10:55 «»
By: pradeepsanthosh
Re: Data Loading problem of French Input file
…for the quick response !!
please find the details below.
1) connecting to oracle
EXEC SQL WHENEVER SQLERROR GOTO connect_error;
EXEC SQL CONNECT :username IDENTIFIED BY :password USING :ssid;
2) structure is
struct …
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 August 2012 03:02 «»
By: nischalinn
Re: incrementally increasing userid value via looping
…I tried this, but got the error:
I do not know whether my approach is right or wrong. Please suggest me the right way to solve my problem.
DECLARE
CURSOR c1 IS
SELECT username FROM reg_user
FOR update;
init NUMBER(10);
lRow …
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 03 August 2012 05:10 «»
By: muralikri
Re: READ FROM A FILE WITH COMMA(,) as Delimiter
…
Fields terminated by ","
(
field1,
field2,
field3,
field4,
field5
)
BEGINDATA
2420362,660064100019390040,476,12,Auth_code
Then run the below command in DOS prompt
c:\> sqlldr control=mk.ctl userid=username/passwd…
|
| 26 |
Forum: Security «»
Posted on: Mon, 28 May 2012 02:44 «»
By: raj9999
How to disable sql login
…to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve …
|
| 27 |
Forum: Forms «»
Posted on: Sun, 06 May 2012 09:13 «»
By: arif_md2009
Re: forms-40010 cannot read form Z:\ORAFMX\GENLOGIN.fmx
…think you need to define the path properly in the shortcut itself maybe there is a space in between userid:=username/password@db, you need to define the db connect .
first check for the .fmx is available or not,
second try to delete it and try to run …
|
| 28 |
Forum: Forms «»
Posted on: Tue, 13 March 2012 06:40 «»
By: mughals_king
Re: How to call bat file from Oracle Form
…am using same thing with but its working fine here anyway try something else like
u can use either SQL Loader or external Tables. or u have to choosed SQL loader option and created a form along with a control file and batch file based.
Control …
|
| 29 |
Forum: Server Administration «»
Posted on: Thu, 26 January 2012 04:59 «»
By: avijeet
ORA-00600: internal error code, arguments: [kcbchg1_11]
…ORA-00600: internal error code, arguments: [kcbchg1_11], [], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Current SQL statement for this session:
insert into sys.aud$( sessionid,entryid,statement,timestamp#, userid,userhost…
|
| 30 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Fri, 18 November 2011 00:54 «»
By: klthaw
Re: SI Object Browser Log on Error
…for your reply,
but i still stunk
Enter into database from Oracle SQL*Plus with following data is OK.
username testname
password testpwd
host string testdatabase
when log on in SI Object Browser with following same data
UserID testname
…
|
| 31 |
Forum: Performance Tuning «»
Posted on: Tue, 27 September 2011 02:24 «»
By: sathik
Query tuning
…
The below query is taking more time (>20 mins) to give the complete output. But the subquery has taken only 28 seconds.
the main query given 1st 15 records in 12 mins, after that it has taken another 7 mins to give next 15 records. Again the cursor …
|
| 32 |
Forum: Enterprise Manager «»
Posted on: Fri, 09 September 2011 11:15 «»
By: BlackSwan
Re: Oracle Intelligent Agent Error
…
bcm@bcm-laptop:~$ proc
Pro*C/C++: Release 11.2.0.1.0 - Production on Fri Sep 9 09:14:12 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
System default option values taken from: /u01/app/oracle/product/11.2.0/…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 23 August 2011 02:49 «»
By: muradtarawneh
Re: oracle
…have table contains username and password
i want procedure to make check on username and password to put it in test website then if username and password true print true else print fulse
here i create one but i want to check it
create or …
|
| 34 |
Forum: Forms «»
Posted on: Sun, 31 July 2011 00:15 «»
By: shanie
Re: Calling Reports Using web.show_document() from Forms
…is done in Unix by the following command
frmcmp_batch.sh module = GZAMAIL.fmb userid = username/password
We didnt compile in Windows Environment.Even if we compile it will give us error in Windows.
I didnt understand this which Form Parameters? I…
|
| 35 |
Forum: Forms «»
Posted on: Sat, 11 June 2011 22:44 «»
By: sethumurugan
Re: Data Upload using SQL loader from forms
…Hi,
You will need a Control file, batch file and Oracle form to do this.
Control File
This will have the details about your table name, its structure with datatype and source file name.
LOAD DATA
INFILE '/apps/alpay/nonconfi/txt/clock_dump.…
|
| 36 |
Forum: Forms «»
Posted on: Thu, 09 June 2011 03:06 «»
By: sethumurugan
Re: Data Upload using SQL loader from forms
…Hi,
I have solved the problem in my local system which is in windows plat form. The following are the codes I have created in when button pressed trigger.
declare
usid varchar2(10):= get_application_property(username);
pwd varchar2(10):= …
|
| 37 |
Forum: Forms «»
Posted on: Wed, 08 June 2011 23:04 «»
By: sethumurugan
Data Upload using SQL loader from forms
…Hi,
Iam working with a form thru which I need to port nearly 7 laks of data into table.
Earlier I had created a form thru which I read the data from the text file and inserting into the table. This was taking lot of time and as well after an hour…
|
| 38 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Tue, 31 May 2011 05:40 «»
By: jamal_s
Re: Generating Scheduler for Some Procedures
…location of yor form is in c:\test\logon.fmb and you want to run this form
what you can do is go to formsweb.cfg and make the following entry
[test]
separateFrame=True
baseHTMLjinitiator=D:\JAMAL\APP10G\basejini.htm
pageTitle=test
form=c:\test\…
|
| 39 |
Forum: Server Administration «»
Posted on: Wed, 25 May 2011 13:34 «»
By: Michel Cadot
Re: Deleting unwanted SYS shema objects
…- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the …
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 13 May 2011 03:15 «»
By: cyberjai
Re: DBMS scheduler Doesnt support the synonym table (DBLINK Used)
…barbara,
Thanks for your vaulable time.
we also tried to insert the data instead of dbms output as suggested by you.
the difference what i able to see between your code and mine is we are working between 2 different DB's and 2 different Schemas…
|
Blog
Search
Help
Members
Register
Login
Home